The DB Upgrader runs the ConvertTablesToANSI utility as part of an iMIS upgrade, but you can run it standalone as well, from the command line. To ensure a smooth upgrade for a large and complex database, you can do a "pre-upgrade" conversion on a backup of the database to anticipate problems.
1. Create a backup, an off-line copy of your database.
2. If you haven’t upgraded, run the iMIS installer to expand copies of the database utilities.
3. Locate the ConvertTablesToANSI utility, in the imis.net\IMISDBUpgrade\Utilities folder.
4. From the command line, run the utility against your database backup:
ConvertTablesToANSI.exe -S sqlServerName -U sqlUser -P sqlPassword -D dbName
If your database copy converts with no errors, you can use this converted database for your upgrade, which saves the time of reconverting. If there is an error, contact Support for assistance before upgrading.